UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oI+nKCSUGyV14M4JWz7hn//LSpGbqmKh3Mm1m0gsQcs='
WHERE
key_id = 'e245c4f6eb80b2069d141a062e75a558a8129fa3122be9311144f66eba834493'
AND (
token = 'oI+nKCSUGyV14M4JWz7hn//LSpGbqmKh3Mm1m0gsQcs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)