UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zd9eovGOdCiVRI5ckGSkT+LyJNLbPVvX8JH8FQ8uk9Y='
WHERE
key_id = 'a78fa085c0198f62cc3d696cc6ab979fa06ec035657e2ba5eb81ebfe978f09e7'
AND (
token = 'zd9eovGOdCiVRI5ckGSkT+LyJNLbPVvX8JH8FQ8uk9Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)