UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zrAwW18pn1DjoN8UO55eN0bTE7S0sBiZeVWy881yY8Q='
WHERE
key_id = '7eef5363171ca12bd595196aeb537c14274e088dbb91952b9da38530afb999a2'
AND (
token = 'zrAwW18pn1DjoN8UO55eN0bTE7S0sBiZeVWy881yY8Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)