UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CHZ0aF9W3j/I3d1stX8KskN7ghhjlFtzTeThA8wC8hE='
WHERE
key_id = 'e8d8811d8e3255c47133c394d0c15685e863905f916c2ace2d11766de937136d'
AND (
token = 'CHZ0aF9W3j/I3d1stX8KskN7ghhjlFtzTeThA8wC8hE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)