UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YjgVaw8GIrXLm0RwCCjEtsklceIoB/pvUX4wv6DXlow='
WHERE
key_id = '29c43afe5619ad123cc78a6873513a6122fe9cccd14c0589dfe5c0518ac6709c'
AND (
token = 'YjgVaw8GIrXLm0RwCCjEtsklceIoB/pvUX4wv6DXlow='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)