UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BV6fEUGglTpJkiaLaRzAoOuqADMiPcj5Gt8bXmra6hE='
WHERE
key_id = '7ddb47b2b0b51626b535eb0bd58663cc728f7ac4b75ca7298184f0ff3efef434'
AND (
token = 'BV6fEUGglTpJkiaLaRzAoOuqADMiPcj5Gt8bXmra6hE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)