UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+4if+tLyO+WRUKkDaHqqJnGD1fPsvmwDBXXdaZXIR34='
WHERE
key_id = 'd747b2b0c25cc7b5a0d0268b6d47a38974b26f978575ed1ba086465804ca87ce'
AND (
token = '+4if+tLyO+WRUKkDaHqqJnGD1fPsvmwDBXXdaZXIR34='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)