UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3NSCds8Pg/V+lTDss5pdgxaM+lsBENa+YzvIOxym3Mg='
WHERE
key_id = '6e4099af34d0e4b92881227a075aa3fd356605a423d910f2f7e0a5ddfd44649c'
AND (
token = '3NSCds8Pg/V+lTDss5pdgxaM+lsBENa+YzvIOxym3Mg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)