UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nuAwzL7O6M+qqQBViL2qq1SEUNF6zY/52L8ZqHXiDIA='
WHERE
key_id = 'ee31576439e3739218bfae4cf52b12323f1595b55a7176075fd6db04ddc6fc95'
AND (
token = 'nuAwzL7O6M+qqQBViL2qq1SEUNF6zY/52L8ZqHXiDIA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)