UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fbRs0XaZtmTQv4Kv9s4Gc7uXNFbm1n5/klNufBtV3Z4='
WHERE
key_id = '478314710ea8c147d2f0d7f5caaacdbe012d304761142e2aa563a8c3ef565ccf'
AND (
token = 'fbRs0XaZtmTQv4Kv9s4Gc7uXNFbm1n5/klNufBtV3Z4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)