UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LBDvHF5My9rlziXYVwYD3YP5zotkf2bxu/QUt4/oyzc='
WHERE
key_id = 'be7e3fd231ace3b58c718887a0d7f991c63c538b9cbd5aec67e217253976fe7e'
AND (
token = 'LBDvHF5My9rlziXYVwYD3YP5zotkf2bxu/QUt4/oyzc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)