UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CcJ972Ht6A18kY6FE7WQKaNXgdpcaM+6DLm7TI8uUEY='
WHERE
key_id = 'd4ebf78cccae195983c9ac5883227f79896cfb35bf1ba6dbaf01001a27b2a0b9'
AND (
token = 'CcJ972Ht6A18kY6FE7WQKaNXgdpcaM+6DLm7TI8uUEY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)