UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3oWMn4qYs01KgwxtKwQ40gMO2hY9f9PTJTO4r9XP/Rk='
WHERE
key_id = 'b7c48769e60eee50aca2bffa192e5492d3a625e58f980b205ebb4583954cb1fd'
AND (
token = '3oWMn4qYs01KgwxtKwQ40gMO2hY9f9PTJTO4r9XP/Rk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)