UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LrMcVlOaQAV/u8RoCvooqoTbDUqp04XTnTGCJTF7eBg='
WHERE
key_id = 'aa99b3d6760ede09ff081a566474e91b93823564eaa6c60a710347b2ee311f96'
AND (
token = 'LrMcVlOaQAV/u8RoCvooqoTbDUqp04XTnTGCJTF7eBg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)