UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OBji6E/zFJ9fXNytuMtJYi13nVFy61N6pQ2XLfvwKgo='
WHERE
key_id = '3e586bc1e70fb154042f2fb4d940eb0f3ffcd08ad767af79542bc7a3aee41180'
AND (
token = 'OBji6E/zFJ9fXNytuMtJYi13nVFy61N6pQ2XLfvwKgo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)