UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nz8jbMpx+OKVpuNrgk7hzITKE+8YYzvnO6KdYY2jtHM='
WHERE
key_id = '12af875a47c853791d81e6a7727cc2ae2e692e81c5250ec5c1ff4a98553332cc'
AND (
token = 'nz8jbMpx+OKVpuNrgk7hzITKE+8YYzvnO6KdYY2jtHM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)