UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BFsoEjiU68jk8BmnJR8GFH4KEd/4bnl+/7jQWItPj+s='
WHERE
key_id = '0906a41b5618aed746f83f8579d734eae363febae9fc8180805f24d2133a6de6'
AND (
token = 'BFsoEjiU68jk8BmnJR8GFH4KEd/4bnl+/7jQWItPj+s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)