UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7DlpTF0w8pJdashWK1S9hgQYDuzXT/ZS+D6hRSVHHqE='
WHERE
key_id = '196fda1b177372950d7180e16c757eafd5cd106789a02fee2f7bf7a0bf936fb4'
AND (
token = '7DlpTF0w8pJdashWK1S9hgQYDuzXT/ZS+D6hRSVHHqE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)