UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'j3XKbsuV8VxCBirMu9TRS/ZSQLLe6pWeNH8pjOGJA64='
WHERE
key_id = 'b4b03af5676ef850e620f93046c97a08ffe49d721a298582d782fb5a27df2a50'
AND (
token = 'j3XKbsuV8VxCBirMu9TRS/ZSQLLe6pWeNH8pjOGJA64='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)