UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5CF6w0uHJqzqfaDc6xxLrg+rdqTQjRZch2tL//nEPwg='
WHERE
key_id = '3a90fac5b4e51fbd95e6d2213b3d2d1e50601813a64a5acbee967088a219236d'
AND (
token = '5CF6w0uHJqzqfaDc6xxLrg+rdqTQjRZch2tL//nEPwg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)