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