UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B1z1iOR/+poTpKcl/SmYoEucZK6vN7RHOaXujT1VLGE='
WHERE
key_id = 'b9179c79b7915790a2dd8cb50203e04c75a8ba82be1d232e1e28fff5261d1240'
AND (
token = 'B1z1iOR/+poTpKcl/SmYoEucZK6vN7RHOaXujT1VLGE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)