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