UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8EU/mWbDjnQhaR1dTyeMQ7/hcowwG19jhiEhp4GIx1g='
WHERE
key_id = '0d7db3c3477ee7690310d0158d60a0a8221268a804aa23c63bb3d018874cf4a2'
AND (
token = '8EU/mWbDjnQhaR1dTyeMQ7/hcowwG19jhiEhp4GIx1g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)