UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9qtpXym5n6y1GRzyKSxTouyz+Ir5kAquG92tnct338Y='
WHERE
key_id = 'a1e4930e4977eac769533faefc5ebce448a5f1fbeef1990f3361255c42d34a01'
AND (
token = '9qtpXym5n6y1GRzyKSxTouyz+Ir5kAquG92tnct338Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)