UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gkFumuwURxi8jiocrTkhyIZF8Un24OjD4e7gDrNFDyQ='
WHERE
key_id = 'cff9da016f1f904f6c200f8b5ea40c2736de2bddb5a414ff825d25a44601c678'
AND (
token = 'gkFumuwURxi8jiocrTkhyIZF8Un24OjD4e7gDrNFDyQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)