UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'so658cHRAViBce5ceXuPrdaYC9YjB/BwVpX25wFocko='
WHERE
key_id = '0afad2b5bb4498fdb7dfd2d3332d4e22dc57a2dd5d32b4a5e69ac79563e23ad1'
AND (
token = 'so658cHRAViBce5ceXuPrdaYC9YjB/BwVpX25wFocko='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)