UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3Ywht4KOIf57O5ZwtC3jXR++CgM7+8NnyRE64AkopAE='
WHERE
key_id = '4d4aba2b37d078b73caa1e114fe8026f3168c84df6ad399a2323f3fa02cdecac'
AND (
token = '3Ywht4KOIf57O5ZwtC3jXR++CgM7+8NnyRE64AkopAE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)