UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qFWX+OjfPNVZiqAbGiFNhlghBF+4ApuyiYArZZ06nc8='
WHERE
key_id = 'e836a907fc13f219378e2f8d4b960cd67cb0f0e2418280ce188b82411aa4e937'
AND (
token = 'qFWX+OjfPNVZiqAbGiFNhlghBF+4ApuyiYArZZ06nc8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)