UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GSRkKPRBwXcEPphXQ7HcWpLBznf7zAP2K0iEcj9MVDc='
WHERE
key_id = 'cbea889dd4306a7f3e344292c467d7b2c32ddc6082a7aa1c8f8a8fb82cac1092'
AND (
token = 'GSRkKPRBwXcEPphXQ7HcWpLBznf7zAP2K0iEcj9MVDc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)