UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pEaod2e6CrM7q/VNS4b9ourUdbFO0Bar3NYpivcuQ2c='
WHERE
key_id = '9a41fa8031fef419c29211a5d255c88537cf896a3d5d670e6f715f558ea62237'
AND (
token = 'pEaod2e6CrM7q/VNS4b9ourUdbFO0Bar3NYpivcuQ2c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)