UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dZzwuDz8LqmcUrvt0wBOF7nlA96UfkaEEo772+IJf10='
WHERE
key_id = '38c5377107d95542ad4e249d2beabf425942b6e72946a732fa4d59b496f7f373'
AND (
token = 'dZzwuDz8LqmcUrvt0wBOF7nlA96UfkaEEo772+IJf10='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)