UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'm5RZ+eIzt9qS4pX7lwyLjZQXvS2gOcZdje7TwccuwyI='
WHERE
key_id = 'a10d0ce9049303efcd41308076e2d4b91297791acda264d3b0200a982cf1df58'
AND (
token = 'm5RZ+eIzt9qS4pX7lwyLjZQXvS2gOcZdje7TwccuwyI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)