UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r+AKwAWzI1dtNBdGDrrpP2EmK6VSq3PSD4lMDNaYtOo='
WHERE
key_id = 'b474a96680490d73d898e07171225d418a826b45d92d6c286b6ec8ee827f8020'
AND (
token = 'r+AKwAWzI1dtNBdGDrrpP2EmK6VSq3PSD4lMDNaYtOo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)