UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EnXnHk5dQzc1oP04SOwiQOWEOCX3/caGAyT86T6mBLs='
WHERE
key_id = '5d00169b3e0124287b4a3b865d57f7520903d74b8b9fee01efd351f18755d454'
AND (
token = 'EnXnHk5dQzc1oP04SOwiQOWEOCX3/caGAyT86T6mBLs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)