UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'n2zZJi/gtYM7bHUgGQj+0iyad6BDn9sI+eIt9497fsM='
WHERE
key_id = 'e2514faf3edef73fac8facf0b6a380fd015f2e2fa5156c76a25501ccd82db60a'
AND (
token = 'n2zZJi/gtYM7bHUgGQj+0iyad6BDn9sI+eIt9497fsM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)