UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6X1yfNynl5F4VTtlssuTr9kEjeCwDAsqWRsKyzABR+M='
WHERE
key_id = '0d254215322533f2673104151d77341bd250134398fc9ce2b91f0f8e0a6f6692'
AND (
token = '6X1yfNynl5F4VTtlssuTr9kEjeCwDAsqWRsKyzABR+M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)