UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kgBGLbauRGA+6ekGUBnSWOtPsi218PmdVkpIlqFz3Gc='
WHERE
key_id = '9ccd47118e23f8f234007c00e251a20c5b30c626c5d23502271ff4d6a7b872ff'
AND (
token = 'kgBGLbauRGA+6ekGUBnSWOtPsi218PmdVkpIlqFz3Gc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)