UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'psORlozwjg5alfBvKkxpp20QB6Nrgcr7JlMkeNu1lJo='
WHERE
key_id = '3bbab44ecd4227b6d1027ae40ea83d1b203a664b3cbe5e2ecad3c78524542768'
AND (
token = 'psORlozwjg5alfBvKkxpp20QB6Nrgcr7JlMkeNu1lJo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)