UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'I04S5bHkk0sv9YAl4xsCj+TvoZsxSZw1i7x3VQAtCVM='
WHERE
key_id = '56bc5b038b50c8981e5c0255339f74be36e3894a9ecf48accb0af03447938611'
AND (
token = 'I04S5bHkk0sv9YAl4xsCj+TvoZsxSZw1i7x3VQAtCVM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)